Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Key	Id	Name	Type	Length	IsNullable	Collation
		SupplierID	int	4
		CompanyName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
		CompanyName	sysname	80		SQL_Latin1_General_CP1_CI_AS
		ContactName	nvarchar	60		SQL_Latin1_General_CP1_CI_AS
		ContactName	sysname	60		SQL_Latin1_General_CP1_CI_AS
		ContactTitle	nvarchar	60		SQL_Latin1_General_CP1_CI_AS
		ContactTitle	sysname	60		SQL_Latin1_General_CP1_CI_AS
		Address	nvarchar	120		SQL_Latin1_General_CP1_CI_AS
		Address	sysname	120		SQL_Latin1_General_CP1_CI_AS
		City	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		City	sysname	30		SQL_Latin1_General_CP1_CI_AS
		Region	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		Region	sysname	30		SQL_Latin1_General_CP1_CI_AS
		PostalCode	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
		PostalCode	sysname	20		SQL_Latin1_General_CP1_CI_AS
		Country	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		Country	sysname	30		SQL_Latin1_General_CP1_CI_AS
		Phone	nvarchar	48		SQL_Latin1_General_CP1_CI_AS
		Phone	sysname	48		SQL_Latin1_General_CP1_CI_AS
		Fax	nvarchar	48		SQL_Latin1_General_CP1_CI_AS
		Fax	sysname	48		SQL_Latin1_General_CP1_CI_AS
		HomePage	ntext	16		SQL_Latin1_General_CP1_CI_AS

Indexes

Name	Description	Group	Keys
PK_Suppliers	clustered, unique, primary key	PRIMARY	SupplierID
CompanyName	nonclustered	PRIMARY	CompanyName
PostalCode	nonclustered	PRIMARY	PostalCode

Relations

Suppliers SupplierID

Products   SupplierID